﻿--HEADER iComply.SuspiciousActivity imprved read model

alter table iComply.SuspiciousActivity
add SigmaMove float null

GO 

update SuspiciousActivity
set sigmamove = ComplianceEvent.SigmaMove
from iCOmply.SuspiciousActivity
join iComply.ComplianceEvent on ComplianceEvent.Id = SuspiciousActivity.EventId

